﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="一分厂半成品收发存表.aspx.cs" Inherits="syc.ChengBen.一分厂.一分厂半成品收发存表" %>
<%@ Import  Namespace="System.Data"%>
<%@ Import  Namespace="System.Data.SqlClient"%>
<%@ Import  Namespace="System.Configuration"%>
<%@ Import  Namespace="NPOI.HSSF.UserModel"%>
<%@ Import  Namespace="NPOI.HPSF"%>
<%@ Import  Namespace="System.IO"%>

<html  >
<head runat="server">
    <title></title>
</head>
<body>
   <script runat="server">
    protected HSSFWorkbook hssfworkbook;
    protected double 套管J55本期收入数量;
    protected double 套管N80本期收入数量;
    protected double 套管J55本期收入金额;
    protected double 套管N80本期收入金额;
       
    protected double 套管J55自产接箍本期收入数量;
    protected double 套管N80自产接箍本期收入数量;
    protected double 套管J55自产接箍本期收入金额;
    protected double 套管N80自产接箍本期收入金额;

    protected double 套管J55外购接箍本期收入数量;
    protected double 套管N80外购接箍本期收入数量;
    protected double 套管J55外购接箍本期收入金额;
    protected double 套管N80外购接箍本期收入金额;

    protected double 本期合计收入金额;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
             Button_Query_Click(null, null);
            this.Year.SelectedValue = DateTime.Today.Year.ToString();
            this.Month.SelectedValue = DateTime.Today.Month.ToString();
        }
    }
    protected void Button_Query_Click(object sender, EventArgs e)
    {
        SqlConnection Conn = new SqlConnection();
        Conn.ConnectionString = ConfigurationManager.ConnectionStrings["SCMConnectionString1"].ConnectionString;
        Conn.Open();
        SqlCommand Cmd = new SqlCommand();
        Cmd.Connection = Conn;
        string sql = @"
           declare @套管J55本期收入数量 float
           declare @套管N80本期收入数量 float
           declare @套管J55本期收入金额 float
           declare @套管N80本期收入金额 float
               
           declare @套管J55自产接箍本期收入数量 float
           declare @套管N80自产接箍本期收入数量 float
           declare @套管J55自产接箍本期收入金额 float
           declare @套管N80自产接箍本期收入金额 float

           declare @套管J55外购接箍本期收入数量 float
           declare @套管N80外购接箍本期收入数量 float
           declare @套管J55外购接箍本期收入金额 float
           declare @套管N80外购接箍本期收入金额 float
           
           select @套管J55本期收入数量=[dbo].[分厂本期收入数量](@年度,@月份,'J55',1,2),@套管J55本期收入金额=[dbo].[分厂本期收入金额](@年度,@月份,'J55',1,2)        
                 ,@套管N80本期收入数量=[dbo].[分厂本期收入数量](@年度,@月份,'N80',1,2),@套管N80本期收入金额=[dbo].[分厂本期收入金额](@年度,@月份,'N80',1,2) 
                 ,@套管J55外购接箍本期收入数量=[dbo].[分厂本期收入数量](@年度,@月份,'J55',1,6),@套管J55外购接箍本期收入金额=[dbo].[分厂本期收入金额](@年度,@月份,'J55',1,6)        
                 ,@套管N80外购接箍本期收入数量=[dbo].[分厂本期收入数量](@年度,@月份,'N80',1,6),@套管N80外购接箍本期收入金额=[dbo].[分厂本期收入金额](@年度,@月份,'N80',1,6) 
                 ,@套管J55自产接箍本期收入数量=[dbo].[分厂本期收入数量](@年度,@月份,'J55',1,4),@套管J55自产接箍本期收入金额=[dbo].[分厂本期收入金额](@年度,@月份,'J55',1,4)        
                 ,@套管N80自产接箍本期收入数量=[dbo].[分厂本期收入数量](@年度,@月份,'N80',1,4),@套管N80自产接箍本期收入金额=[dbo].[分厂本期收入金额](@年度,@月份,'N80',1,4) 
           select   @套管J55本期收入数量,@套管J55本期收入金额,@套管N80本期收入数量,@套管N80本期收入金额
                   ,@套管J55外购接箍本期收入数量,@套管J55外购接箍本期收入金额,@套管N80外购接箍本期收入数量,@套管N80外购接箍本期收入金额                         
                   ,@套管J55自产接箍本期收入数量,@套管J55自产接箍本期收入金额,@套管N80自产接箍本期收入数量,@套管N80自产接箍本期收入金额
";
        sql = sql.Replace("@年度", this.Year.Text);
        sql = sql.Replace("@月份", this.Month.Text);
        Cmd.CommandText = sql;
        SqlDataReader Reader = Cmd.ExecuteReader();

        if (Reader.Read())
        {
            套管J55本期收入数量 = Double.Parse(Reader[0].ToString());
            套管J55本期收入金额 = Double.Parse(Reader[1].ToString());
            套管N80本期收入数量 = Double.Parse(Reader[2].ToString());
            套管N80本期收入金额 = Double.Parse(Reader[3].ToString());
            套管J55外购接箍本期收入数量 = Double.Parse(Reader[4].ToString());
            套管J55外购接箍本期收入金额 = Double.Parse(Reader[5].ToString());
            套管N80外购接箍本期收入数量 = Double.Parse(Reader[6].ToString());
            套管N80外购接箍本期收入金额 = Double.Parse(Reader[7].ToString());
            套管J55自产接箍本期收入数量 = Double.Parse(Reader[8].ToString());
            套管J55自产接箍本期收入金额 = Double.Parse(Reader[9].ToString());
            套管N80自产接箍本期收入数量 = Double.Parse(Reader[10].ToString());
            套管N80自产接箍本期收入金额 = Double.Parse(Reader[11].ToString());   
        }
        Reader.Close();
        本期合计收入金额 = 套管J55本期收入金额 + 套管N80本期收入金额 + 套管J55外购接箍本期收入金额 + 套管N80外购接箍本期收入金额
            + 套管J55自产接箍本期收入金额 + 套管N80自产接箍本期收入金额;
        Cmd.Clone();
        Conn.Close();
    }
    protected void WriteToFile()
    {
        DateTime d;
        d = DateTime.Today;
        Response.ContentType = "application/ms-excel";
        Response.AddHeader("content-disposition", "attachment; filename=\"" + d.ToShortDateString() + ".xls\"");
        hssfworkbook.Write(Response.OutputStream);
    }

    protected void InitializeWorkbook()
    {

        FileStream file = new FileStream(HttpContext.Current.Server.MapPath("/ChengBen/一分厂/模板/半成品收发存表.xls"), FileMode.Open, FileAccess.Read);

        hssfworkbook = new HSSFWorkbook(file);

        DocumentSummaryInformation dsi = PropertySetFactory.CreateDocumentSummaryInformation();
        dsi.Company = "陕西延长石油材料有限公司";
        hssfworkbook.DocumentSummaryInformation = dsi;

        SummaryInformation si = PropertySetFactory.CreateSummaryInformation();
        si.Subject = "报表";
        si.Title = "一分厂半成品收发存表";
        hssfworkbook.SummaryInformation = si;
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        InitializeWorkbook();
        HSSFSheet sheet1 = hssfworkbook.GetSheet("半成品收发存表");
        sheet1.GetRow(1).GetCell(0).SetCellValue(this.Year.Text + "年" + this.Month.Text + "月");
        Button_Query_Click(null, null);
        sheet1.GetRow(5).GetCell(3).SetCellValue(套管J55本期收入数量);
        sheet1.GetRow(5).GetCell(4).SetCellValue(套管J55本期收入金额);
        sheet1.GetRow(5).GetCell(5).SetCellValue(套管J55本期收入数量);
        sheet1.GetRow(5).GetCell(6).SetCellValue(套管J55本期收入金额);

        sheet1.GetRow(6).GetCell(3).SetCellValue(套管N80本期收入数量);
        sheet1.GetRow(6).GetCell(4).SetCellValue(套管N80本期收入金额);
        sheet1.GetRow(6).GetCell(5).SetCellValue(套管N80本期收入数量);
        sheet1.GetRow(6).GetCell(6).SetCellValue(套管N80本期收入金额);


        sheet1.GetRow(7).GetCell(3).SetCellValue(套管J55外购接箍本期收入数量);
        sheet1.GetRow(7).GetCell(4).SetCellValue(套管J55外购接箍本期收入金额);
        sheet1.GetRow(7).GetCell(5).SetCellValue(套管J55外购接箍本期收入数量);
        sheet1.GetRow(7).GetCell(6).SetCellValue(套管J55外购接箍本期收入金额);

        sheet1.GetRow(8).GetCell(3).SetCellValue(套管N80外购接箍本期收入数量);
        sheet1.GetRow(8).GetCell(4).SetCellValue(套管N80外购接箍本期收入金额);
        sheet1.GetRow(8).GetCell(5).SetCellValue(套管N80外购接箍本期收入数量);
        sheet1.GetRow(8).GetCell(6).SetCellValue(套管N80外购接箍本期收入金额);

        sheet1.GetRow(9).GetCell(3).SetCellValue(套管J55自产接箍本期收入数量);
        sheet1.GetRow(9).GetCell(4).SetCellValue(套管J55自产接箍本期收入金额);
        sheet1.GetRow(9).GetCell(5).SetCellValue(套管J55自产接箍本期收入数量);
        sheet1.GetRow(9).GetCell(6).SetCellValue(套管J55自产接箍本期收入金额);


        sheet1.GetRow(10).GetCell(3).SetCellValue(套管N80自产接箍本期收入数量);
        sheet1.GetRow(10).GetCell(4).SetCellValue(套管N80自产接箍本期收入金额);
        sheet1.GetRow(10).GetCell(5).SetCellValue(套管N80自产接箍本期收入数量);
        sheet1.GetRow(10).GetCell(6).SetCellValue(套管N80自产接箍本期收入金额);

     
        sheet1.GetRow(11).GetCell(4).SetCellValue(本期合计收入金额);    
        sheet1.GetRow(11).GetCell(6).SetCellValue(本期合计收入金额);

        string op = (String)Session["OperatorName"];
        sheet1.GetRow(12).GetCell(6).SetCellValue("制表：" + op);
        WriteToFile();
        Response.End();
    }
   </script>
    <script type="text/javascript" language="javascript" src="/common.js"></script>
   <form id="form1" runat="server">
   <div id="wintop" class="wintop"><span lang="zh-cn">一分厂半成品收发存表</span></div>
        <asp:Panel ID="Panel1" runat="server" CssClass="panel" Height="36px" >   
              年份：<asp:DropDownList ID="Year" runat="server">         
            <asp:ListItem>2010</asp:ListItem>
            <asp:ListItem>2011</asp:ListItem>
            <asp:ListItem>2012</asp:ListItem>
            <asp:ListItem>2013</asp:ListItem>
            <asp:ListItem>2014</asp:ListItem>
            <asp:ListItem>2015</asp:ListItem>   
            <asp:ListItem>2016</asp:ListItem>
            <asp:ListItem>2017</asp:ListItem>
            <asp:ListItem>2018</asp:ListItem>
            <asp:ListItem>2019</asp:ListItem>
            <asp:ListItem>2020</asp:ListItem>                
            </asp:DropDownList>
            <span lang="zh-cn">&nbsp;月份：</span><asp:DropDownList ID="Month" runat="server">
                <asp:ListItem>1</asp:ListItem>
                <asp:ListItem>2</asp:ListItem>
                <asp:ListItem>3</asp:ListItem>
                <asp:ListItem>4</asp:ListItem>
                <asp:ListItem>5</asp:ListItem>
                <asp:ListItem>6</asp:ListItem>
                <asp:ListItem>7</asp:ListItem>
                <asp:ListItem>8</asp:ListItem>
                <asp:ListItem>9</asp:ListItem>
                <asp:ListItem>10</asp:ListItem>
                <asp:ListItem>11</asp:ListItem>
                <asp:ListItem>12</asp:ListItem>
            </asp:DropDownList>
      <span lang="zh-cn">&nbsp;&nbsp;</span><asp:Button ID="Button_Query"
            runat="server" Text="查看报表" CssClass="button" UseSubmitBehavior="true" onclick="Button_Query_Click" 
             />            
            &nbsp;<asp:Button ID="Button1" runat="server" class="button" onclick="Button1_Click" 
                Text="导 出" />
      </asp:Panel>
        <asp:Panel ID="Panel2" runat="server" CssClass="panel2">
        <asp:Label ID="Message" runat="server" Text="·准备就绪" CssClass="prompt" Visible="True"></asp:Label>
        </asp:Panel> 
     <div align="center"> 
    <style>
<!--table
	{mso-displayed-decimal-separator:"\.";
	mso-displayed-thousand-separator:"\,";}
@page
	{margin:1.0in .75in 1.0in .98in;
	mso-header-margin:.5in;
	mso-footer-margin:.5in;
	mso-page-orientation:landscape;}
.font5
	{color:windowtext;
	font-size:12.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;}
tr
	{mso-height-source:auto;
	mso-ruby-visibility:none;}
col
	{mso-width-source:auto;
	mso-ruby-visibility:none;}
br
	{mso-data-placement:same-cell;}
.style0
	{mso-number-format:General;
	text-align:general;
	vertical-align:middle;
	white-space:nowrap;
	mso-rotate:0;
	mso-background-source:auto;
	mso-pattern:auto;
	color:windowtext;
	font-size:12.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	border:none;
	mso-protection:locked visible;
	mso-style-name:常规;
	mso-style-id:0;}
td
	{mso-style-parent:style0;
	padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:12.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	mso-number-format:General;
	text-align:general;
	vertical-align:middle;
	border:none;
	mso-background-source:auto;
	mso-pattern:auto;
	mso-protection:locked visible;
	white-space:nowrap;
	mso-rotate:0;}
.xl24
	{mso-style-parent:style0;
	font-size:16.0pt;
	text-align:center;}
.xl25
	{mso-style-parent:style0;
	text-align:center;
	border:.5pt solid windowtext;}
.xl26
	{mso-style-parent:style0;
	font-size:10.0pt;
	text-align:center;
	border:.5pt solid windowtext;}
.xl27
	{mso-style-parent:style0;
	font-size:10.0pt;
	mso-number-format:"0\.00_\)\;\[Red\]\\\(0\.00\\\)";
	text-align:center;
	border:.5pt solid windowtext;}
.xl28
	{mso-style-parent:style0;
	font-size:10.0pt;
	mso-number-format:"0\.00_ ";
	text-align:center;
	border:.5pt solid windowtext;}
.xl29
	{mso-style-parent:style0;
	text-align:center;}
.xl30
	{mso-style-parent:style0;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:none;
	border-left:none;}
.xl31
	{mso-style-parent:style0;
	mso-number-format:"yyyy\0022年\0022m\0022月\0022";
	text-align:center;}
.xl32
	{mso-style-parent:style0;
	font-family:"Times New Roman", serif;
	mso-font-charset:0;
	text-align:right;
	border-top:none;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	white-space:normal;}
.xl33
	{mso-style-parent:style0;
	font-family:"Times New Roman", serif;
	mso-font-charset:0;
	text-align:right;
	border-top:none;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:none;}
ruby
	{ruby-align:left;}
rt
	{color:windowtext;
	font-size:9.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	mso-char-type:none;
	display:none;}
-->
</style>
<!--[if gte mso 9]><xml>
 <x:ExcelWorkbook>
  <x:ExcelWorksheets>
   <x:ExcelWorksheet>
    <x:Name>半成品收发存表</x:Name>
    <x:WorksheetOptions>
     <x:DefaultRowHeight>285</x:DefaultRowHeight>
     <x:Print>
      <x:ValidPrinterInfo/>
      <x:PaperSizeIndex>9</x:PaperSizeIndex>
      <x:HorizontalResolution>600</x:HorizontalResolution>
      <x:VerticalResolution>600</x:VerticalResolution>
     </x:Print>
     <x:Selected/>
     <x:Panes>
      <x:Pane>
       <x:Number>3</x:Number>
       <x:ActiveRow>19</x:ActiveRow>
       <x:ActiveCol>2</x:ActiveCol>
      </x:Pane>
     </x:Panes>
     <x:ProtectContents>False</x:ProtectContents>
     <x:ProtectObjects>False</x:ProtectObjects>
     <x:ProtectScenarios>False</x:ProtectScenarios>
    </x:WorksheetOptions>
   </x:ExcelWorksheet>
   <x:ExcelWorksheet>
    <x:Name>Sheet2</x:Name>
    <x:WorksheetOptions>
     <x:DefaultRowHeight>285</x:DefaultRowHeight>
     <x:ProtectContents>False</x:ProtectContents>
     <x:ProtectObjects>False</x:ProtectObjects>
     <x:ProtectScenarios>False</x:ProtectScenarios>
    </x:WorksheetOptions>
   </x:ExcelWorksheet>
   <x:ExcelWorksheet>
    <x:Name>Sheet3</x:Name>
    <x:WorksheetOptions>
     <x:DefaultRowHeight>285</x:DefaultRowHeight>
     <x:ProtectContents>False</x:ProtectContents>
     <x:ProtectObjects>False</x:ProtectObjects>
     <x:ProtectScenarios>False</x:ProtectScenarios>
    </x:WorksheetOptions>
   </x:ExcelWorksheet>
  </x:ExcelWorksheets>
  <x:WindowHeight>10350</x:WindowHeight>
  <x:WindowWidth>14940</x:WindowWidth>
  <x:WindowTopX>360</x:WindowTopX>
  <x:WindowTopY>75</x:WindowTopY>
  <x:ProtectStructure>False</x:ProtectStructure>
  <x:ProtectWindows>False</x:ProtectWindows>
 </x:ExcelWorkbook>
</xml><![endif]-->
</head>

<body link=blue vlink=purple>

<table x:str border=0 cellpadding=0 cellspacing=0 width=912 style='border-collapse:
 collapse;table-layout:fixed;width:686pt'>
 <col width=137 style='mso-width-source:userset;mso-width-alt:4384;width:103pt'>
 <col width=94 style='mso-width-source:userset;mso-width-alt:3008;width:71pt'>
 <col width=101 style='mso-width-source:userset;mso-width-alt:3232;width:76pt'>
 <col width=88 style='mso-width-source:userset;mso-width-alt:2816;width:66pt'>
 <col width=96 style='mso-width-source:userset;mso-width-alt:3072;width:72pt'>
 <col width=81 style='mso-width-source:userset;mso-width-alt:2592;width:61pt'>
 <col width=113 style='mso-width-source:userset;mso-width-alt:3616;width:85pt'>
 <col width=96 style='mso-width-source:userset;mso-width-alt:3072;width:72pt'>
 <col width=106 style='mso-width-source:userset;mso-width-alt:3392;width:80pt'>
 <tr height=43 style='mso-height-source:userset;height:32.25pt'>
  <td colspan=9 height=43 class=xl24 width=912 style='height:32.25pt;
  width:686pt'>原材料、半成品收发存表</td>
 </tr>
 <tr height=29 style='mso-height-source:userset;height:21.75pt'>
  <td colspan=9 height=29 class=xl31 style='height:21.75pt' x:num="40575">2011年2月</td>
 </tr>
 <tr height=27 style='mso-height-source:userset;height:20.25pt'>
  <td colspan=9 height=27 class=xl32 width=912 style='height:20.25pt;
  width:686pt'><span
  style='mso-spacerun:yes'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  </span><font class="font5">单位：元、吨</font></td>
 </tr>
 <tr height=34 style='mso-height-source:userset;height:25.5pt'>
  <td rowspan=2 height=68 class=xl25 style='height:51.0pt;border-top:none'>项目</td>
  <td colspan=2 class=xl25 style='border-left:none'>期初</td>
  <td colspan=2 class=xl25 style='border-left:none'>本期收入</td>
  <td colspan=2 class=xl25 style='border-left:none'>本期支出</td>
  <td colspan=2 class=xl25 style='border-left:none'>结存</td>
 </tr>
 <tr height=34 style='mso-height-source:userset;height:25.5pt'>
  <td height=34 class=xl25 style='height:25.5pt;border-top:none;border-left:
  none'>数量</td>
  <td class=xl25 style='border-top:none;border-left:none'>金额</td>
  <td class=xl25 style='border-top:none;border-left:none'>数量</td>
  <td class=xl25 style='border-top:none;border-left:none'>金额</td>
  <td class=xl25 style='border-top:none;border-left:none'>数量</td>
  <td class=xl25 style='border-top:none;border-left:none'>金额</td>
  <td class=xl25 style='border-top:none;border-left:none'>数量</td>
  <td class=xl25 style='border-top:none;border-left:none'>金额</td>
 </tr>
 <tr height=34 style='mso-height-source:userset;height:25.5pt'>
  <td height=34 class=xl26 style='height:25.5pt;border-top:none'>J55套管</td>
  <td class=xl26 style='border-top:none;border-left:none'>　</td>
  <td class=xl27 style='border-top:none;border-left:none'>　</td>
  <td class=xl26 style='border-top:none;border-left:none'
  ><%=套管J55本期收入数量%></td>
  <td class=xl26 style='border-top:none;border-left:none'
  ><%=套管J55本期收入金额%></td>
  <td class=xl26 style='border-top:none;border-left:none'
  ><%=套管J55本期收入数量%></td>
  <td class=xl26 style='border-top:none;border-left:none'
  ><%=套管J55本期收入金额%></td>
  <td class=xl26 style='border-top:none;border-left:none'>　</td>
  <td class=xl28 style='border-top:none;border-left:none'>　</td>
 </tr>
 <tr height=34 style='mso-height-source:userset;height:25.5pt'>
  <td height=34 class=xl26 style='height:25.5pt;border-top:none'>N80套管</td>
  <td class=xl26 style='border-top:none;border-left:none'>　</td>
  <td class=xl27 style='border-top:none;border-left:none'>　</td>
  <td class=xl26 style='border-top:none;border-left:none'
  ><%=套管N80本期收入数量%></td>
  <td class=xl26 style='border-top:none;border-left:none'
  ><%=套管N80本期收入金额%></td>
  <td class=xl26 style='border-top:none;border-left:none'
  ><%=套管N80本期收入数量%></td>
  <td class=xl26 style='border-top:none;border-left:none'
  ><%=套管N80本期收入金额%></td>
  <td class=xl26 style='border-top:none;border-left:none'>　</td>
  <td class=xl28 style='border-top:none;border-left:none'>　</td>
 </tr>
 <tr height=34 style='mso-height-source:userset;height:25.5pt'>
  <td height=34 class=xl26 style='height:25.5pt;border-top:none'>J55套管外购接箍</td>
  <td class=xl26 style='border-top:none;border-left:none'>　</td>
  <td class=xl27 style='border-top:none;border-left:none'>　</td>
  <td class=xl26 style='border-top:none;border-left:none'
  ><%=套管J55外购接箍本期收入数量%></td>
  <td class=xl26 style='border-top:none;border-left:none'
  ><%=套管J55外购接箍本期收入金额%></td>
  <td class=xl26 style='border-top:none;border-left:none'
  ><%=套管J55外购接箍本期收入数量%></td>
  <td class=xl26 style='border-top:none;border-left:none'
  ><%=套管J55外购接箍本期收入金额%></td>
  <td class=xl26 style='border-top:none;border-left:none'>　</td>
  <td class=xl28 style='border-top:none;border-left:none'>　</td>
 </tr>
 <tr height=34 style='mso-height-source:userset;height:25.5pt'>
  <td height=34 class=xl26 style='height:25.5pt;border-top:none'>N80套管外购接箍</td>
  <td class=xl26 style='border-top:none;border-left:none'>　</td>
  <td class=xl27 style='border-top:none;border-left:none'>　</td>
  <td class=xl26 style='border-top:none;border-left:none'
  ><%=套管N80外购接箍本期收入数量%></td>
  <td class=xl26 style='border-top:none;border-left:none'
  ><%=套管N80外购接箍本期收入金额%></td>
  <td class=xl26 style='border-top:none;border-left:none'
  ><%=套管N80外购接箍本期收入数量%></td>
  <td class=xl26 style='border-top:none;border-left:none'
  ><%=套管N80外购接箍本期收入金额%></td>
  <td class=xl26 style='border-top:none;border-left:none'>　</td>
  <td class=xl28 style='border-top:none;border-left:none'>　</td>
 </tr>
 <tr height=34 style='mso-height-source:userset;height:25.5pt'>
  <td height=34 class=xl26 style='height:25.5pt;border-top:none'>J55套管自制接箍</td>
  <td class=xl26 style='border-top:none;border-left:none'>　</td>
  <td class=xl27 style='border-top:none;border-left:none'>　</td>
  <td class=xl26 style='border-top:none;border-left:none'
  ><%=套管J55自产接箍本期收入数量%></td>
  <td class=xl26 style='border-top:none;border-left:none'
  ><%=套管J55自产接箍本期收入金额%></td>
  <td class=xl26 style='border-top:none;border-left:none'
  ><%=套管J55自产接箍本期收入数量%></td>
  <td class=xl26 style='border-top:none;border-left:none'
  ><%=套管J55自产接箍本期收入金额%></td>
  <td class=xl26 style='border-top:none;border-left:none'>　</td>
  <td class=xl28 style='border-top:none;border-left:none'>　</td>
 </tr>
 <tr height=34 style='mso-height-source:userset;height:25.5pt'>
  <td height=34 class=xl26 style='height:25.5pt;border-top:none'>N80套管自制接箍</td>
  <td class=xl26 style='border-top:none;border-left:none'>　</td>
  <td class=xl27 style='border-top:none;border-left:none'>　</td>
 <td class=xl26 style='border-top:none;border-left:none'
  ><%=套管N80自产接箍本期收入数量%></td>
  <td class=xl26 style='border-top:none;border-left:none'
  ><%=套管N80自产接箍本期收入金额%></td>
  <td class=xl26 style='border-top:none;border-left:none'
  ><%=套管N80自产接箍本期收入数量%></td>
  <td class=xl26 style='border-top:none;border-left:none'
  ><%=套管N80自产接箍本期收入金额%></td>
  <td class=xl26 style='border-top:none;border-left:none'>　</td>
  <td class=xl28 style='border-top:none;border-left:none'>　</td>
 </tr>
 <tr height=34 style='mso-height-source:userset;height:25.5pt'>
  <td height=34 class=xl26 style='height:25.5pt;border-top:none'>合计</td>
  <td class=xl26 style='border-top:none;border-left:none'>　</td>
  <td class=xl27 style='border-top:none;border-left:none'>　</td>
  <td class=xl26 style='border-top:none;border-left:none'>　</td>
  <td class=xl26 style='border-top:none;border-left:none'
  ><%=本期合计收入金额%></td>
  <td class=xl26 style='border-top:none;border-left:none'>　</td>
  <td class=xl27 style='border-top:none;border-left:none'
  ><%=本期合计收入金额%></td>
  <td class=xl26 style='border-top:none;border-left:none'>　</td>
  <td class=xl28 style='border-top:none;border-left:none'>　</td>
 </tr>
 <tr height=30 style='mso-height-source:userset;height:22.5pt'>
  <td height=30 class=xl29 style='height:22.5pt'></td>
  <td colspan=2 class=xl30>单位负责人：</td>
  <td colspan=3 class=xl29 style='mso-ignore:colspan'></td>
  <td colspan=2 class=xl30>制表：刘弘波</td>
  <td class=xl29></td>
 </tr>
 <![if supportMisalignedColumns]>
 <tr height=0 style='display:none'>
  <td width=137 style='width:103pt'></td>
  <td width=94 style='width:71pt'></td>
  <td width=101 style='width:76pt'></td>
  <td width=88 style='width:66pt'></td>
  <td width=96 style='width:72pt'></td>
  <td width=81 style='width:61pt'></td>
  <td width=113 style='width:85pt'></td>
  <td width=96 style='width:72pt'></td>
  <td width=106 style='width:80pt'></td>
 </tr>
 <![endif]>
</table>
    </div>
    </form>
</body>
</html>
